﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ZhimeiSoft.CharmManager.Server.DAL
{
    public class ServiceItemCategoryDAL_Const
    {
        public static readonly string SQL_INSERT_SERVICEITEMCATEGORY = "INSERT INTO SERVICEITEMCATEGORY(SNAME, SPARENTCATEGORYID) VALUES (@SNAME, @SPARENTCATEGORYID)";

        public static readonly string SQL_UPDATE_SERVICEITEMCATEGORY = "UPDATE SERVICEITEMCATEGORY SET SNAME=@SNAME, SPARENTCATEGORYID=@SPARENTCATEGORYID WHERE SCATEGORYID=@SCATEGORYID";

        public static readonly string SQL_DELETE_SERVICEITEMCATEGORY = "DELETE FROM SERVICEITEMCATEGORY WHERE SCATEGORYID=@SCATEGORYID";

        public static readonly string SQL_SELECT_SERVICEITEMCATEGORY = "SELECT * FROM SERVICEITEMCATEGORY";
    }
}
